These are the tables and fields involved in EXPOCAD:
Expo_Control
Stored in System_Params where ParameterName = Expo_Control. Additional fields have been added to the Expo_Control table. These fields will be used in the Expo System Setup window.
|
Column Name |
Data Type/Size |
Description |
|
UseQtyOrSqrFt |
Boolean |
0 if using Quantity 1 if using Area (Square Units) |
|
ImportRunning |
Boolean |
1 if import is running |
ExpoCad_Prod
Stores the product mapping between EXPOCAD and iMIS.
|
Column Name |
Data Type/Size |
Description |
|
MEET_ID |
Char(10) |
Event in EXPOCAD Exposition code in iMIS |
|
ExpoCad_Type |
Char(40) |
Booth Type in EXPOCAD Island, Peninsula, Corner, Inline, Custom and Aisle Booth |
|
Product_Code |
Char(31) |
Exposition ‘Booth’ product code |
|
Premium_1 |
Char(31) |
Exposition ‘Other’ or ‘Paid Pass’ product code |
|
Qty_1 |
Numeric |
Quantity for Premium_1 |
|
Premium_2 |
Char(31) |
Exposition ‘Other’ or ‘Paid Pass’ product code |
|
Qty_2 |
Numeric |
Quantity for Premium_2 |
Meet_Master
Additional field has been added.
|
Column Name |
Data Type/Size |
Description |
|
Meet_Category |
Numeric |
0 if iMIS exposition 1 if EXPOCAD exposition |
Exhb_Booth
Additional field has been added.
|
Column Name |
Data Type/Size |
Description |
|
Booth_Type |
Char(40) |
Stores the Booth Type from EXPOCAD |
EXPOCAD: ExpoCadExp
A FoxPro database file created when an event in EXPOCAD is initially setup.
|
Column Name |
Data Type/Size |
Description |
|
Count_Val |
Numeric(18) |
Value of the current counter. Equal to 0 when Proc_Desc =‘iMISCounter’ |
|
UniqueID |
Numeric(18) |
Unique ID generated from the increment of Count_Val |
|
Orig_Booth |
Char(20) |
Original Booth Number |
|
New_Booth |
Char(20) |
New Booth Number |
|
Booth_Size |
Numeric(18) |
Size of booth in square units |
|
Booth_Type |
Char(40) |
Booth Type in EXPOCAD Island, Peninsula, Corner, Inline, Custom and ab |
|
Exhb_ID |
Char(20) |
Exhibitor ID |
|
Event_Name |
Char(20) |
Event name in EXPOCAD Exposition name in iMIS |
|
Proc_Desc |
Char(100) |
Description of EXPOCAD activity ‘Rent Booth’,’Unrent Booth’,’Booth Num Change’,’Booth Class Change’, and ‘iMISCounter’ |
|
Insert_Dat |
Char(22) |
Date record was added in EXPOCAD stored in CCYYMMDD HH:MM:SS format |
|
Retrv_By |
Char(100) |
Upon successful import, stores the UserID+RetrieveDate, marking that line for deletion. If the record fails the import, stores FAIL_UserID+RetrieveDate |